select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Sweetheart Empire Lavender Ruched Chiffon Knee-length Dama Dress
One Shoulder Champagne Dama Dress with Handmade Flower and Belt
Lavender Beaded One Shoulder Chiffon Knee-length Dama Dress
One Shoulder Pleated Pink Chiffon Empire Brush Train Dama Dress
Baby Pink Sweetheart Quinceanera Gown with Appliques and Overskirt
Popular Purple Sweet Sixteen Dresses with Embroidery and Pick-ups
Custom Made Strapless Embroidery Quinceanera Dress with Overskirt
Exquisite Halter Embroidered Olive Green Dress for Quinceaneras
Wonderful Spring Green Paillette Sweet 16 Dress with Appliques
Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket
Fuchsia Ball Gown Dresses for Sweet15th with Beading in Taffeta
Chic Flower Decorate 2012 Lilac Sweet 15 Gown Tiered
Lavender Strapless Ball Gown Sweet 15 Dresses with Beading
White Ball Gown Strapless Pink Sequins Sweet Sixteen Dresses
Beading Strapless Ball Gown Sweet 15 Dresses in Light Yellow
A-line Sweetheart Embroidery and Beading Baby Blue Sweet 15 Dresses
Quinceanera Dress Strapless with Embroidery and Beading in Baby Blue
Baby Pink Sweetheart Quinceanera Dress with Beaded Sweetheart
A-line Strapless Appliques Paillette Sweet Sixteen Dresses in Blue
Aqua Blue Sweetheart Appliques Lace up Quinceanera Dresses
Ruching Sweetheart Baby Pink Quinceanera Dress with Layered Ruffles
Burgundy Ball Gown Sweetheart Appliques Sweet 16 Dresses
Strapless Beading Purple Ball Gown Sweet 15 Dresses with Ruffles
Teal Ball Gown Strapless Beading Ruffled Sweet Sixteen Dresses
Lilac Sweetheart Ball Gown Sweet 16 Dresses with Appliques
Lilac and Black Bateau Neckline Ball Gown Sweet Sixteen Dresses
Aqua Blue Ball Gown Sweetheart Beaded Quinceanera Dresses
Ruffled Multi-Color Ball Gown Strapless Quinceanera Gown Dresses
Gray Ball Gown Strapless Floor-length Appliques Sweet 15 Dresses
Strapless Appliques Ball Gown Pick-ups Dresses for Quinceanera